/*
 Source Server         : Balder
 Source Server Type    : SQL Server
 Source Server Version : 10501617
 Source Host           : balder.ucn.dk
 Source Database       : dmaa0212a_5
 Source Schema         : dbo

 Target Server Type    : SQL Server
 File Encoding         : utf-8

 Date: 2013-04-09
*/

-- ----------------------------
--  Table structure for [dbo].[Actor]
-- ----------------------------
CREATE TABLE [dbo].[Actor] (
	[Id] int IDENTITY(1,1) NOT NULL,
	[Name] varchar(255) COLLATE Danish_Norwegian_CI_AS NOT NULL,
	CONSTRAINT [PK__Actor__3213E83F07020F21] PRIMARY KEY CLUSTERED ([Id]) 
	WITH (PAD_INDEX = OFF,
		IGNORE_DUP_KEY = OFF,
		ALLOW_ROW_LOCKS = ON,
		ALLOW_PAGE_LOCKS = ON)
	ON [PRIMARY]
)
ON [PRIMARY]
GO
ALTER TABLE [dbo].[Actor] SET (LOCK_ESCALATION = TABLE)
GO
DBCC CHECKIDENT ('[dbo].[Actor]', RESEED, 1)

-- ----------------------------
--  Table structure for [dbo].[Cinema]
-- ----------------------------
CREATE TABLE [dbo].[Cinema] (
	[Id] int IDENTITY(1,1) NOT NULL,
	[Name] varchar(255) COLLATE Danish_Norwegian_CI_AS NOT NULL,
	[Location] varchar(255) COLLATE Danish_Norwegian_CI_AS NOT NULL,
	CONSTRAINT [PK__Cinema__3213E83F0AD2A005] PRIMARY KEY CLUSTERED ([Id]) 
	WITH (PAD_INDEX = OFF,
		IGNORE_DUP_KEY = OFF,
		ALLOW_ROW_LOCKS = ON,
		ALLOW_PAGE_LOCKS = ON)
	ON [PRIMARY],
	CONSTRAINT [unique_NameLocation] UNIQUE NONCLUSTERED (Name ASC, Location ASC) 
	WITH (PAD_INDEX = OFF,
		IGNORE_DUP_KEY = OFF,
		ALLOW_ROW_LOCKS = ON,
		ALLOW_PAGE_LOCKS = ON)
	ON [PRIMARY]
)
ON [PRIMARY]
GO
ALTER TABLE [dbo].[Cinema] SET (LOCK_ESCALATION = TABLE)
GO
DBCC CHECKIDENT ('[dbo].[Cinema]', RESEED, 1)

-- ----------------------------
--  Table structure for [dbo].[Movie]
-- ----------------------------
CREATE TABLE [dbo].[Movie] (
	[Id] int IDENTITY(1,1) NOT NULL,
	[Title] varchar(255) COLLATE Danish_Norwegian_CI_AS NOT NULL,
	[Genre] varchar(255) COLLATE Danish_Norwegian_CI_AS NOT NULL,
	[Length] int NOT NULL,
	[Description] varchar(255) COLLATE Danish_Norwegian_CI_AS NOT NULL,
	[Price] int NOT NULL,
	CONSTRAINT [PK__Movie__3214EC0703317E3D] PRIMARY KEY CLUSTERED ([Id]) 
	WITH (PAD_INDEX = OFF,
		IGNORE_DUP_KEY = OFF,
		ALLOW_ROW_LOCKS = ON,
		ALLOW_PAGE_LOCKS = ON)
	ON [PRIMARY]
)
ON [PRIMARY]
GO
ALTER TABLE [dbo].[Movie] SET (LOCK_ESCALATION = TABLE)
GO
DBCC CHECKIDENT ('[dbo].[Movie]', RESEED, 1)

-- ----------------------------
--  Table structure for [dbo].[User]
-- ----------------------------
CREATE TABLE [dbo].[User] (
	[PhoneNo] char(8) COLLATE Danish_Norwegian_CI_AS NOT NULL,
	[Name] varchar(255) COLLATE Danish_Norwegian_CI_AS NOT NULL,
	[Address] varchar(255) COLLATE Danish_Norwegian_CI_AS NOT NULL,
	[Type] varchar(20) COLLATE Danish_Norwegian_CI_AS NOT NULL,
	[Initials] char(4) COLLATE Danish_Norwegian_CI_AS NULL,
	[Age] int NULL,
	CONSTRAINT [PK__User__960F17EE1DE57479] PRIMARY KEY CLUSTERED ([PhoneNo]) 
	WITH (PAD_INDEX = OFF,
		IGNORE_DUP_KEY = OFF,
		ALLOW_ROW_LOCKS = ON,
		ALLOW_PAGE_LOCKS = ON)
	ON [PRIMARY],
	CONSTRAINT [check_userType] CHECK ([Type]='customer' OR [Type]='employee')
)
ON [PRIMARY]
GO
ALTER TABLE [dbo].[User] SET (LOCK_ESCALATION = TABLE)

-- ----------------------------
--  Table structure for [dbo].[Movie_Actor]
-- ----------------------------
CREATE TABLE [dbo].[Movie_Actor] (
	[ActorId] int NOT NULL,
	[MovieId] int NOT NULL,
	CONSTRAINT [PK__Movie_Ac__771CE27F1367E606] PRIMARY KEY CLUSTERED ([ActorId],[MovieId]) 
	WITH (PAD_INDEX = OFF,
		IGNORE_DUP_KEY = OFF,
		ALLOW_ROW_LOCKS = ON,
		ALLOW_PAGE_LOCKS = ON)
	ON [PRIMARY],
	CONSTRAINT [fk_MovieActorMovie] FOREIGN KEY ([MovieId]) REFERENCES [dbo].[Movie] ([Id]) ON DELETE CASCADE ON UPDATE NO ACTION,
	CONSTRAINT [fk_MovieActorActor] FOREIGN KEY ([ActorId]) REFERENCES [dbo].[Actor] ([Id]) ON DELETE CASCADE ON UPDATE NO ACTION
)
ON [PRIMARY]
GO
ALTER TABLE [dbo].[Movie_Actor] SET (LOCK_ESCALATION = TABLE)

-- ----------------------------
--  Table structure for [dbo].[Movie_Cinema]
-- ----------------------------
CREATE TABLE [dbo].[Movie_Cinema] (
	[CinemaId] int NOT NULL,
	[MovieId] int NOT NULL,
	CONSTRAINT [PK__Movie_Ci__BA492C1C164452B1] PRIMARY KEY CLUSTERED ([CinemaId],[MovieId]) 
	WITH (PAD_INDEX = OFF,
		IGNORE_DUP_KEY = OFF,
		ALLOW_ROW_LOCKS = ON,
		ALLOW_PAGE_LOCKS = ON)
	ON [PRIMARY],
	CONSTRAINT [fk_MovieCinemaMovie] FOREIGN KEY ([MovieId]) REFERENCES [dbo].[Movie] ([Id]) ON DELETE CASCADE ON UPDATE NO ACTION,
	CONSTRAINT [fk_MovieCinemaCinema] FOREIGN KEY ([CinemaId]) REFERENCES [dbo].[Cinema] ([Id]) ON DELETE CASCADE ON UPDATE NO ACTION
)
ON [PRIMARY]
GO
ALTER TABLE [dbo].[Movie_Cinema] SET (LOCK_ESCALATION = TABLE)

-- ----------------------------
--  Table structure for [dbo].[Booking]
-- ----------------------------
CREATE TABLE [dbo].[Booking] (
	[Id] int IDENTITY(1,1) NOT NULL,
	[Creation_date] datetime2(0) NOT NULL DEFAULT (sysdatetime()),
	[UserPhoneNo] char(8) COLLATE Danish_Norwegian_CI_AS NOT NULL,
	CONSTRAINT [PK__Booking__3213E83F267ABA7A] PRIMARY KEY CLUSTERED ([Id]) 
	WITH (PAD_INDEX = OFF,
		IGNORE_DUP_KEY = OFF,
		ALLOW_ROW_LOCKS = ON,
		ALLOW_PAGE_LOCKS = ON)
	ON [PRIMARY],
	CONSTRAINT [fk_BookingUser] FOREIGN KEY ([UserPhoneNo]) REFERENCES [dbo].[User] ([PhoneNo]) ON DELETE CASCADE ON UPDATE NO ACTION
)
ON [PRIMARY]
GO
ALTER TABLE [dbo].[Booking] SET (LOCK_ESCALATION = TABLE)
GO
DBCC CHECKIDENT ('[dbo].[Booking]', RESEED, 1)

-- ----------------------------
--  Table structure for [dbo].[MovieHall]
-- ----------------------------
CREATE TABLE [dbo].[MovieHall] (
	[Id] int IDENTITY(1,1) NOT NULL,
	[Number] int NOT NULL,
	[CinemaId] int NOT NULL,
	CONSTRAINT [PK__MovieHal__3213E83F21B6055D] PRIMARY KEY CLUSTERED ([Id]) 
	WITH (PAD_INDEX = OFF,
		IGNORE_DUP_KEY = OFF,
		ALLOW_ROW_LOCKS = ON,
		ALLOW_PAGE_LOCKS = ON)
	ON [PRIMARY],
	CONSTRAINT [fk_MovieHallCinema] FOREIGN KEY ([CinemaId]) REFERENCES [dbo].[Cinema] ([Id]) ON DELETE CASCADE ON UPDATE NO ACTION,
	CONSTRAINT [unique_NumberCinema] UNIQUE NONCLUSTERED (Number ASC, CinemaId ASC) 
	WITH (PAD_INDEX = OFF,
		IGNORE_DUP_KEY = OFF,
		ALLOW_ROW_LOCKS = ON,
		ALLOW_PAGE_LOCKS = ON)
	ON [PRIMARY]
)
ON [PRIMARY]
GO
ALTER TABLE [dbo].[MovieHall] SET (LOCK_ESCALATION = TABLE)
GO
DBCC CHECKIDENT ('[dbo].[MovieHall]', RESEED, 1)

-- ----------------------------
--  Table structure for [dbo].[Seat]
-- ----------------------------
CREATE TABLE [dbo].[Seat] (
	[Id] int IDENTITY(1,1) NOT NULL,
	[MovieHallId] int NOT NULL,
	[Row] int NOT NULL,
	[Number] int NOT NULL,
	[Price] int NOT NULL,
	CONSTRAINT [PK__Seat__3213E83F36B12243] PRIMARY KEY CLUSTERED ([Id]) 
	WITH (PAD_INDEX = OFF,
		IGNORE_DUP_KEY = OFF,
		ALLOW_ROW_LOCKS = ON,
		ALLOW_PAGE_LOCKS = ON)
	ON [PRIMARY],
	CONSTRAINT [fk_SeatMovieHall] FOREIGN KEY ([MovieHallId]) REFERENCES [dbo].[MovieHall] ([Id]) ON DELETE CASCADE ON UPDATE NO ACTION,
	CONSTRAINT [unique_MovieHallRowNumber] UNIQUE NONCLUSTERED (MovieHallId ASC, Row ASC, Number ASC) 
	WITH (PAD_INDEX = OFF,
		IGNORE_DUP_KEY = OFF,
		ALLOW_ROW_LOCKS = ON,
		ALLOW_PAGE_LOCKS = ON)
	ON [PRIMARY]
)
ON [PRIMARY]
GO
ALTER TABLE [dbo].[Seat] SET (LOCK_ESCALATION = TABLE)
GO
DBCC CHECKIDENT ('[dbo].[Seat]', RESEED, 1)

-- ----------------------------
--  Table structure for [dbo].[PartBooking]
-- ----------------------------
CREATE TABLE [dbo].[PartBooking] (
	[Id] int IDENTITY(1,1) NOT NULL,
	[BookingId] int NOT NULL,
	[AgeGroup] char(1) COLLATE Danish_Norwegian_CI_AS NOT NULL,
	[ScreenCast_SeatId] int NOT NULL,
	CONSTRAINT [PK__PartBook__3213E83F31EC6D26] PRIMARY KEY CLUSTERED ([Id]) 
	WITH (PAD_INDEX = OFF,
		IGNORE_DUP_KEY = OFF,
		ALLOW_ROW_LOCKS = ON,
		ALLOW_PAGE_LOCKS = ON)
	ON [PRIMARY],
	CONSTRAINT [fk_PartBookingBooking] FOREIGN KEY ([BookingId]) REFERENCES [dbo].[Booking] ([Id]) ON DELETE CASCADE ON UPDATE NO ACTION,
	CONSTRAINT [fk_PartBookingScreenCast_Seat] FOREIGN KEY ([ScreenCast_SeatId]) REFERENCES [dbo].[ScreenCast_Seat] ([Id]) ON DELETE NO ACTION ON UPDATE NO ACTION,
	CONSTRAINT [unique_BookingSeat] UNIQUE NONCLUSTERED (BookingId ASC, SeatId ASC) 
	WITH (PAD_INDEX = OFF,
		IGNORE_DUP_KEY = OFF,
		ALLOW_ROW_LOCKS = ON,
		ALLOW_PAGE_LOCKS = ON)
	ON [PRIMARY]
)
ON [PRIMARY]
GO
ALTER TABLE [dbo].[PartBooking] SET (LOCK_ESCALATION = TABLE)
GO
DBCC CHECKIDENT ('[dbo].[PartBooking]', RESEED, 1)

-- ----------------------------
--  Table structure for [dbo].[ScreenCast]
-- ----------------------------
CREATE TABLE [dbo].[ScreenCast] (
	[Id] int IDENTITY(1,1) NOT NULL,
	[Airdate] datetime2(0) NOT NULL,
	[Price] int NOT NULL,
	[MovieId] int NOT NULL,
	[MovieHallId] int NOT NULL,
	CONSTRAINT [PK__ScreenCa__3213E83F5535A963] PRIMARY KEY CLUSTERED ([Id]) 
	WITH (PAD_INDEX = OFF,
		IGNORE_DUP_KEY = OFF,
		ALLOW_ROW_LOCKS = ON,
		ALLOW_PAGE_LOCKS = ON)
	ON [PRIMARY],
	CONSTRAINT [fk_ScreenCastMovie] FOREIGN KEY ([MovieId]) REFERENCES [dbo].[Movie] ([Id]) ON DELETE CASCADE ON UPDATE NO ACTION,
	CONSTRAINT [fk_ScreenCastMovieHall] FOREIGN KEY ([MovieHallId]) REFERENCES [dbo].[MovieHall] ([Id]) ON DELETE CASCADE ON UPDATE NO ACTION,
	CONSTRAINT [unique_MovieHallAirdate] UNIQUE NONCLUSTERED (Airdate ASC, MovieHallId ASC) 
	WITH (PAD_INDEX = OFF,
		IGNORE_DUP_KEY = OFF,
		ALLOW_ROW_LOCKS = ON,
		ALLOW_PAGE_LOCKS = ON)
	ON [PRIMARY]
)
ON [PRIMARY]
GO
ALTER TABLE [dbo].[ScreenCast] SET (LOCK_ESCALATION = TABLE)
GO
DBCC CHECKIDENT ('[dbo].[ScreenCast]', RESEED, 1)

-- ----------------------------
--  Table structure for [dbo].[ScreenCast_Seat]
-- ----------------------------
CREATE TABLE [dbo].[ScreenCast_Seat] (
	[Id] int IDENTITY(1,1) NOT NULL,
	[ScreenCastId] int NOT NULL,
	[SeatId] int NOT NULL,
	[SeatAvailable] bit NOT NULL,
	[PartBookingId] int NULL,
	CONSTRAINT [PK__ScreenCast_Seat] PRIMARY KEY CLUSTERED ([Id]) 
	WITH (PAD_INDEX = OFF,
		IGNORE_DUP_KEY = OFF,
		ALLOW_ROW_LOCKS = ON,
		ALLOW_PAGE_LOCKS = ON)
	ON [PRIMARY],
	CONSTRAINT [fk_ScreenCast_Seat_ScreenCast] FOREIGN KEY ([ScreenCastId]) REFERENCES [dbo].[ScreenCast] ([Id]) ON DELETE NO ACTION ON UPDATE NO ACTION,
	CONSTRAINT [fk_ScreenCast_Seat_Seat] FOREIGN KEY ([SeatId]) REFERENCES [dbo].[Seat] ([Id]) ON DELETE NO ACTION ON UPDATE NO ACTION,
	CONSTRAINT [fk_ScreenCast_Seat_PartBooking] FOREIGN KEY ([PartBookingId]) REFERENCES [dbo].[PartBooking] ON DELETE NO ACTION ON UPDATE NO ACTION,
	CONSTRAINT [DF_ScreenCast_Seat_SeatAvailable] DEFAULT ((1)) FOR [SeatAvailable]
)
ON [PRIMARY]
GO
ALTER TABLE [dbo].[ScreenCast_Seat] SET (LOCK_ESCALATION = TABLE)

-- ----------------------------
--  Records of [dbo].[Actor]
-- ----------------------------
BEGIN TRANSACTION
GO
INSERT INTO [dbo].[Actor] ([Name]) VALUES ('Van Diesel');
INSERT INTO [dbo].[Actor] ([Name]) VALUES ('Jason Statham');
INSERT INTO [dbo].[Actor] ([Name]) VALUES ('Robert Dinero');
INSERT INTO [dbo].[Actor] ([Name]) VALUES ('Sylvester Stallone');
GO
COMMIT
GO

-- ----------------------------
--  Records of [dbo].[Cinema]
-- ----------------------------
BEGIN TRANSACTION
GO
INSERT INTO [dbo].[Cinema] ([Name], [Location]) VALUES ('Biocity', 'Aalborg');
INSERT INTO [dbo].[Cinema] ([Name], [Location]) VALUES ('Biocity', 'København');
INSERT INTO [dbo].[Cinema] ([Name], [Location]) VALUES ('Biocity', 'Aarhus');
INSERT INTO [dbo].[Cinema] ([Name], [Location]) VALUES ('Imperial', 'København');
GO
COMMIT
GO

-- ----------------------------
--  Records of [dbo].[Movie]
-- ----------------------------
BEGIN TRANSACTION
GO
INSERT INTO [dbo].[Movie] ([Title], [Genre], [Length], [Description], [Price]) VALUES ('Blade', 'Action/Horror', '120', 'Vampire', '120');
INSERT INTO [dbo].[Movie] ([Title], [Genre], [Length], [Description], [Price]) VALUES ('Blade 2', 'Action/Horror', '110', 'Vampire be back', '100');
INSERT INTO [dbo].[Movie] ([Title], [Genre], [Length], [Description], [Price]) VALUES ('Die Hard', 'Action', '90', 'Boom', '90');
INSERT INTO [dbo].[Movie] ([Title], [Genre], [Length], [Description], [Price]) VALUES ('Die Hard 2', 'Action', '95', 'Boom once again', '100');
GO
COMMIT
GO

-- ----------------------------
--  Records of [dbo].[User]
-- ----------------------------
BEGIN TRANSACTION
GO
INSERT INTO [dbo].[User] VALUES ('10100001', 'Hans Jensen', 'Hansengade 1', 'employee', 'HAJE', null);
INSERT INTO [dbo].[User] VALUES ('10100002', 'Else Sørensen', 'Elsegade 88', 'employee', 'ELSØ', null);
INSERT INTO [dbo].[User] VALUES ('20202020', 'Ander Andersen', 'Andersengade 8', 'customer', null, '21');
INSERT INTO [dbo].[User] VALUES ('30303030', 'Jens Jensen', 'Jensengade 11', 'customer', null, '45');
INSERT INTO [dbo].[User] VALUES ('40404040', 'Jytte Jyttesen', 'Jyttesensgade 90', 'customer', null, '67');
GO
COMMIT
GO

-- ----------------------------
--  Records of [dbo].[Movie_Actor]
-- ----------------------------
BEGIN TRANSACTION
GO
INSERT INTO [dbo].[Movie_Actor] VALUES ('1', '1');
INSERT INTO [dbo].[Movie_Actor] VALUES ('1', '2');
INSERT INTO [dbo].[Movie_Actor] VALUES ('2', '3');
INSERT INTO [dbo].[Movie_Actor] VALUES ('2', '4');
INSERT INTO [dbo].[Movie_Actor] VALUES ('3', '2');
INSERT INTO [dbo].[Movie_Actor] VALUES ('3', '3');
INSERT INTO [dbo].[Movie_Actor] VALUES ('4', '1');
INSERT INTO [dbo].[Movie_Actor] VALUES ('4', '2');
INSERT INTO [dbo].[Movie_Actor] VALUES ('4', '3');
GO
COMMIT
GO

-- ----------------------------
--  Records of [dbo].[Movie_Cinema]
-- ----------------------------
BEGIN TRANSACTION
GO
INSERT INTO [dbo].[Movie_Cinema] VALUES ('1', '1');
INSERT INTO [dbo].[Movie_Cinema] VALUES ('1', '2');
INSERT INTO [dbo].[Movie_Cinema] VALUES ('1', '3');
INSERT INTO [dbo].[Movie_Cinema] VALUES ('2', '1');
INSERT INTO [dbo].[Movie_Cinema] VALUES ('2', '2');
INSERT INTO [dbo].[Movie_Cinema] VALUES ('2', '3');
INSERT INTO [dbo].[Movie_Cinema] VALUES ('2', '4');
INSERT INTO [dbo].[Movie_Cinema] VALUES ('3', '2');
INSERT INTO [dbo].[Movie_Cinema] VALUES ('3', '4');
INSERT INTO [dbo].[Movie_Cinema] VALUES ('4', '4');
GO
COMMIT
GO

-- ----------------------------
--  Records of [dbo].[MovieHall]
-- ----------------------------
BEGIN TRANSACTION
GO
INSERT INTO [dbo].[MovieHall] ([Number], [CinemaId]) VALUES ('1', '1');
INSERT INTO [dbo].[MovieHall] ([Number], [CinemaId]) VALUES ('1', '2');
INSERT INTO [dbo].[MovieHall] ([Number], [CinemaId]) VALUES ('1', '3');
INSERT INTO [dbo].[MovieHall] ([Number], [CinemaId]) VALUES ('1', '4');
INSERT INTO [dbo].[MovieHall] ([Number], [CinemaId]) VALUES ('2', '1');
INSERT INTO [dbo].[MovieHall] ([Number], [CinemaId]) VALUES ('2', '2');
INSERT INTO [dbo].[MovieHall] ([Number], [CinemaId]) VALUES ('2', '3');
INSERT INTO [dbo].[MovieHall] ([Number], [CinemaId]) VALUES ('3', '1');
INSERT INTO [dbo].[MovieHall] ([Number], [CinemaId]) VALUES ('3', '2');
INSERT INTO [dbo].[MovieHall] ([Number], [CinemaId]) VALUES ('3', '3');
INSERT INTO [dbo].[MovieHall] ([Number], [CinemaId]) VALUES ('4', '2');
INSERT INTO [dbo].[MovieHall] ([Number], [CinemaId]) VALUES ('5', '2');
GO
COMMIT
GO

-- ----------------------------
--  Records of [dbo].[Seat]
-- ----------------------------
BEGIN TRANSACTION
GO
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('1', '1', '1', '0');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('1', '1', '2', '0');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('1', '1', '3', '0');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('1', '1', '4', '0');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('1', '2', '1', '5');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('1', '2', '2', '5');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('1', '2', '3', '5');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('1', '2', '4', '5');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('1', '3', '1', '10');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('1', '3', '2', '10');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('1', '3', '3', '10');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('1', '3', '4', '10');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('2', '1', '1', '0');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('2', '1', '2', '0');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('2', '1', '3', '0');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('2', '1', '4', '0');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('2', '2', '1', '5');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('2', '2', '2', '5');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('2', '2', '3', '5');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('2', '2', '4', '5');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('2', '3', '1', '10');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('2', '3', '2', '10');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('2', '3', '3', '10');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('2', '3', '4', '10');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('2', '4', '1', '5');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('2', '4', '2', '5');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('2', '4', '3', '5');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('2', '4', '4', '5');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('3', '1', '1', '0');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('3', '1', '2', '0');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('3', '1', '3', '0');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('3', '1', '4', '0');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('3', '2', '1', '5');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('3', '2', '2', '5');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('3', '2', '3', '5');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('3', '2', '4', '5');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('3', '3', '1', '10');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('3', '3', '2', '10');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('3', '3', '3', '10');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('3', '3', '4', '10');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('4', '1', '1', '0');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('4', '1', '2', '0');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('4', '1', '3', '0');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('4', '1', '4', '0');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('4', '2', '1', '5');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('4', '2', '2', '5');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('4', '2', '3', '5');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('4', '2', '4', '5');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('4', '3', '1', '10');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('4', '3', '2', '10');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('4', '3', '3', '10');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('4', '3', '4', '10');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('4', '4', '1', '5');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('4', '4', '2', '5');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('4', '4', '3', '5');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('4', '4', '4', '5');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('5', '1', '1', '0');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('5', '1', '2', '0');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('5', '1', '3', '0');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('5', '1', '4', '0');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('5', '2', '1', '5');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('5', '2', '2', '5');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('5', '2', '3', '5');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('5', '2', '4', '5');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('5', '3', '1', '10');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('5', '3', '2', '10');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('5', '3', '3', '10');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('5', '3', '4', '10');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('6', '1', '1', '0');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('6', '1', '2', '0');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('6', '1', '3', '0');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('6', '1', '4', '0');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('6', '2', '1', '5');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('6', '2', '2', '5');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('6', '2', '3', '5');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('6', '2', '4', '5');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('6', '3', '1', '10');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('6', '3', '2', '10');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('6', '3', '3', '10');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('6', '3', '4', '10');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('6', '4', '1', '5');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('6', '4', '2', '5');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('6', '4', '3', '5');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('6', '4', '4', '5');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('7', '1', '1', '0');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('7', '1', '2', '0');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('7', '1', '3', '0');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('7', '1', '4', '0');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('7', '2', '1', '5');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('7', '2', '2', '5');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('7', '2', '3', '5');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('7', '2', '4', '5');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('7', '3', '1', '10');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('7', '3', '2', '10');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('7', '3', '3', '10');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('7', '3', '4', '10');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('8', '1', '1', '0');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('8', '1', '2', '0');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('8', '1', '3', '0');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('8', '1', '4', '0');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('8', '2', '1', '5');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('8', '2', '2', '5');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('8', '2', '3', '5');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('8', '2', '4', '5');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('8', '3', '1', '10');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('8', '3', '2', '10');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('8', '3', '3', '10');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('8', '3', '4', '10');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('8', '4', '1', '5');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('8', '4', '2', '5');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('8', '4', '3', '5');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('8', '4', '4', '5');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('9', '1', '1', '0');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('9', '1', '2', '0');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('9', '1', '3', '0');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('9', '1', '4', '0');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('9', '2', '1', '5');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('9', '2', '2', '5');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('9', '2', '3', '5');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('9', '2', '4', '5');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('9', '3', '1', '10');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('9', '3', '2', '10');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('9', '3', '3', '10');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('9', '3', '4', '10');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('10', '1', '1'  '0');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('10', '1', '2'  '0');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('10', '1', '3'  '0');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('10', '1', '4'  '0');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('10', '2', '1'  '5');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('10', '2', '2'  '5');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('10', '2', '3'  '5');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('10', '2', '4'  '5');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('10', '3', '1'  '10');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('10', '3', '2'  '10');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('10', '3', '3'  '10');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('10', '3', '4'  '10');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('11', '1', '1'  '0');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('11', '1', '2'  '0');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('11', '1', '3'  '0');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('11', '1', '4'  '0');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('11', '2', '1'  '5');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('11', '2', '2'  '5');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('11', '2', '3'  '5');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('11', '2', '4'  '5');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('11', '3', '1'  '10');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('11', '3', '2'  '10');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('11', '3', '3'  '10');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('11', '3', '4'  '10');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('11', '4', '1'  '5');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('11', '4', '2'  '5');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('11', '4', '3'  '5');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('11', '4', '4'  '5');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('12', '1', '1'  '0');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('12', '1', '2'  '0');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('12', '1', '3'  '0');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('12', '1', '4'  '0');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('12', '2', '1'  '5');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('12', '2', '2'  '5');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('12', '2', '3'  '5');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('12', '2', '4'  '5');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('12', '3', '1'  '10');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('12', '3', '2'  '10');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('12', '3', '3'  '10');
INSERT INTO [dbo].[Seat] ([MovieHallId], [Row], [Number], [Price]) VALUES ('12', '3', '4'  '10');
GO
COMMIT
GO

-- ----------------------------
--  Records of [dbo].[ScreenCast]
-- ----------------------------
BEGIN TRANSACTION
GO
INSERT INTO [dbo].[ScreenCast] ([Airdate], [Price], [MovieId], [MovieHallId]) VALUES ('2014-01-01 20:00:00', '10', '1', '1');
INSERT INTO [dbo].[ScreenCast] ([Airdate], [Price], [MovieId], [MovieHallId]) VALUES ('2014-02-02 12:00:00', '0', '2', '1');
INSERT INTO [dbo].[ScreenCast] ([Airdate], [Price], [MovieId], [MovieHallId]) VALUES ('2014-03-03 21:30:00', '15', '3', '1');
INSERT INTO [dbo].[ScreenCast] ([Airdate], [Price], [MovieId], [MovieHallId]) VALUES ('2014-02-02 12:00:00', '0', '1', '2');
INSERT INTO [dbo].[ScreenCast] ([Airdate], [Price], [MovieId], [MovieHallId]) VALUES ('2014-03-03 20:00:00', '10', '2', '2');
INSERT INTO [dbo].[ScreenCast] ([Airdate], [Price], [MovieId], [MovieHallId]) VALUES ('2014-02-04 12:00:00', '0', '3', '2');
INSERT INTO [dbo].[ScreenCast] ([Airdate], [Price], [MovieId], [MovieHallId]) VALUES ('2014-03-04 21:30:00', '15', '4', '2');
INSERT INTO [dbo].[ScreenCast] ([Airdate], [Price], [MovieId], [MovieHallId]) VALUES ('2014-02-02 12:00:00', '0', '2', '3');
INSERT INTO [dbo].[ScreenCast] ([Airdate], [Price], [MovieId], [MovieHallId]) VALUES ('2014-03-03 21:30:00', '15', '3', '3');
INSERT INTO [dbo].[ScreenCast] ([Airdate], [Price], [MovieId], [MovieHallId]) VALUES ('2014-02-02 12:00:00', '0', '2', '4');
INSERT INTO [dbo].[ScreenCast] ([Airdate], [Price], [MovieId], [MovieHallId]) VALUES ('2014-03-03 21:30:00', '15', '3', '4');
INSERT INTO [dbo].[ScreenCast] ([Airdate], [Price], [MovieId], [MovieHallId]) VALUES ('2014-02-02 12:00:00', '0', '1', '5');
INSERT INTO [dbo].[ScreenCast] ([Airdate], [Price], [MovieId], [MovieHallId]) VALUES ('2014-03-03 20:00:00', '10', '2', '5');
INSERT INTO [dbo].[ScreenCast] ([Airdate], [Price], [MovieId], [MovieHallId]) VALUES ('2014-02-04 12:00:00', '0', '3', '5');
INSERT INTO [dbo].[ScreenCast] ([Airdate], [Price], [MovieId], [MovieHallId]) VALUES ('2014-03-04 21:30:00', '15', '4', '5');
INSERT INTO [dbo].[ScreenCast] ([Airdate], [Price], [MovieId], [MovieHallId]) VALUES ('2014-02-02 12:00:00', '0', '2', '6');
INSERT INTO [dbo].[ScreenCast] ([Airdate], [Price], [MovieId], [MovieHallId]) VALUES ('2014-03-03 21:30:00', '15', '3', '6');
INSERT INTO [dbo].[ScreenCast] ([Airdate], [Price], [MovieId], [MovieHallId]) VALUES ('2014-02-02 12:00:00', '0', '2', '7');
INSERT INTO [dbo].[ScreenCast] ([Airdate], [Price], [MovieId], [MovieHallId]) VALUES ('2014-03-03 21:30:00', '15', '3', '7');
INSERT INTO [dbo].[ScreenCast] ([Airdate], [Price], [MovieId], [MovieHallId]) VALUES ('2014-02-02 12:00:00', '0', '1', '8');
INSERT INTO [dbo].[ScreenCast] ([Airdate], [Price], [MovieId], [MovieHallId]) VALUES ('2014-03-03 20:00:00', '10', '2', '8');
INSERT INTO [dbo].[ScreenCast] ([Airdate], [Price], [MovieId], [MovieHallId]) VALUES ('2014-02-04 12:00:00', '0', '3', '8');
INSERT INTO [dbo].[ScreenCast] ([Airdate], [Price], [MovieId], [MovieHallId]) VALUES ('2014-03-04 21:30:00', '15', '4', '8');
INSERT INTO [dbo].[ScreenCast] ([Airdate], [Price], [MovieId], [MovieHallId]) VALUES ('2014-02-02 12:00:00', '0', '2', '9');
INSERT INTO [dbo].[ScreenCast] ([Airdate], [Price], [MovieId], [MovieHallId]) VALUES ('2014-03-03 21:30:00', '15', '3', '9');
INSERT INTO [dbo].[ScreenCast] ([Airdate], [Price], [MovieId], [MovieHallId]) VALUES ('2014-02-02 12:00:00', '0', '2', '10');
INSERT INTO [dbo].[ScreenCast] ([Airdate], [Price], [MovieId], [MovieHallId]) VALUES ('2014-03-03 21:30:00', '15', '3', '10');
INSERT INTO [dbo].[ScreenCast] ([Airdate], [Price], [MovieId], [MovieHallId]) VALUES ('2014-02-02 12:00:00', '0', '1', '11');
INSERT INTO [dbo].[ScreenCast] ([Airdate], [Price], [MovieId], [MovieHallId]) VALUES ('2014-03-03 20:00:00', '10', '2', '11');
INSERT INTO [dbo].[ScreenCast] ([Airdate], [Price], [MovieId], [MovieHallId]) VALUES ('2014-02-04 12:00:00', '0', '3', '11');
INSERT INTO [dbo].[ScreenCast] ([Airdate], [Price], [MovieId], [MovieHallId]) VALUES ('2014-03-04 21:30:00', '15', '4', '11');
INSERT INTO [dbo].[ScreenCast] ([Airdate], [Price], [MovieId], [MovieHallId]) VALUES ('2014-02-02 12:00:00', '0', '2', '12');
INSERT INTO [dbo].[ScreenCast] ([Airdate], [Price], [MovieId], [MovieHallId]) VALUES ('2014-03-03 21:30:00', '15', '3', '12');
GO
COMMIT
GO

-- ----------------------------
--  Records of [dbo].[ScreenCast_Seat]
-- ----------------------------
INSERT INTO [dmaa0212a_5].[dbo].[ScreenCast_Seat]
           ([ScreenCastId]
           ,[SeatId])
        select
			a.[Id],
			b.[Id]
		from [dmaa0212a_5].[dbo].[ScreenCast] a
		join [dmaa0212a_5].[dbo].[Seat] b
			on a.[MovieHallId]=b.[MovieHallId];